Release 10.1A: OpenEdge Data Management:
SQL Reference

Scalar functions

Table 50 lists OpenEdge SQL scalar functions. A check mark identifies the compatibility of the function as SQL-92 compatible, ODBC compatible, or a Progress® extension.

Table 50: Compatibility of SQL-92 scalar functions

Scalar function	SQL-92	ODBC	Progress extension	Notes
ABS	–		–	–
ACOS	–		–	–
ADD_MONTHS	–	–		–
ASCII	–		–	–
ASIN	–		–	–
ATAN	–		–	–
ATAN2	–		–	–
CAST		–	–	–
CEILING	–		–	–
CHAR	–		–	–
CHR	–	–		–
COALESCE		–	–	–
CONCAT	–		–	–
CONVERT	–		–	Requires ODBC escape clause – { fn }
CONVERT	–	–		Not compatible with ODBC CONVERT
COS	–		–	–
CURDATE	–		–	–
CURTIME	–		–	–
DATABASE	–		–	–
DAYNAME	–		–	–
DAYOFMONTH	–		–	–
DAYOFWEEK	–		–	–
DAYOFYEAR	–		–	–
DB_NAME	–	–		–
DECODE	–	–		–
DEGREES	–		–	–
EXP	–		–	–
FLOOR	–		–	–
GREATEST	–	–		–
HOUR	–		–	–
IFNULL	–		–	–
INITCAP	–	–		–
INSERT	–		–	–
INSTR	–	–		–
LAST_DAY	–	–		–
LCASE	–		–	–
LEAST	–	–		–
LEFT	–		–	–
LENGTH	–		–	–
LOCATE	–		–	–
LOG10	–		–	–
LOWER		–	–	–
LPAD	–	–		–
LTRIM	–		–	–
MINUTE	–		–	–
MOD	–		–	–
MONTH	–		–	–
MONTHNAME	–		–	–
MONTHS_BETWEEN	–	–		–
NEXT_DAY	–	–		–
NOW	–		–	–
NULLIF		–	–	–
NVL	–	–		–
PI	–		–	–
POWER	–	–		–
PREFIX	–	–		–
PRO_ARR_DESCAPE	–	–		–
PRO_ARR_ESCAPE	–	–		–
PRO_ELEMENT	–	–		–
QUARTER	–		–	–
RADIAN	–		–	–
RAND	–		–	–
REPEAT	–		–	–
REPLACE	–		–	–
RIGHT	–		–	–
ROUND	–	–		–
ROWID	–	–		–
RPAD	–	–		–
RTRIM	–		–	–
SECOND	–		–	–
SIGN	–		–	–
SIN	–		–	–
SQRT	–		–	–
SUBSTR	–	–		–
SUBSTRING	–		–	–
SUFFIX	–	–		–
SYSDATE	–	–		–
SYSTIME	–	–		–
SYSTIMESTAMP	–	–		–
TAN	–		–	–
TO_CHAR	–	–		–
TO_DATE	–	–		–
TO_NUMBER	–	–		–
TO_TIME	–	–		–
TO_TIMESTAMP	–	–		–
TRANSLATE	–	–		–
UCASE	–		–	–
UPPER		–	–	–
USER				–
WEEK	–		–	–
YEAR	–		–	–